var _sqlFmtLoaded = false;
    function convert(input) {
        if (!input || !input.trim()) return '';
        var dialect = (document.getElementById('sql-dialect') || {}).value || 'sql';
        var mode = (document.getElementById('sql-mode') || {}).value || 'format';

        if (mode === 'minify') {
            return input
                .replace(/--[^\n]*/g, '')
                .replace(/\/\*[\s\S]*?\*\//g, '')
                .replace(/\s+/g, ' ')
                .replace(/\s*([(),;])\s*/g, '$1')
                .trim();
        }

        if (!_sqlFmtLoaded) {
            loadScriptPromise('https://cdnjs.cloudflare.com/ajax/libs/sql-formatter/15.4.5/sql-formatter.min.js').then(function() {
                _sqlFmtLoaded = true;
                $('#box1').trigger('keyup');
            }).catch(function() {
                _sqlFmtLoaded = 'failed';
                $('#box1').trigger('keyup');
            });
            return 'Loading formatter...';
        }
        if (_sqlFmtLoaded === 'failed' || typeof sqlFormatter === 'undefined') {
            return 'Formatter failed to load. Please check your connection and try again.';
        }
        try {
            return sqlFormatter.format(input, { language: dialect, tabWidth: 2, keywordCase: 'upper' });
        } catch (e) {
            return 'Could not format SQL: ' + e.message;
        }
    }
    $(function(){
        $('#sql-dialect, #sql-mode').on('change', function(){ $('#box1').trigger('keyup'); });
    });







var _loadedScripts = {};
function loadScriptPromise(url) {
    if (_loadedScripts[url]) return _loadedScripts[url];
    _loadedScripts[url] = new Promise(function (resolve, reject) {
        var s = document.createElement('script');
        s.src = url;
        s.onload = resolve;
        s.onerror = reject;
        document.head.appendChild(s);
    });
    return _loadedScripts[url];
}

function replaceAll(find, replace, str) {
    return str.replace(new RegExp(find, 'g'), replace);
}

function beautify(str) {


    var result = '';

    var length = str.length;

    var i = 0;

    var braceCountLeft = 0;
    var braceCountRight = 0;

    var withinQuotes = false;

    while (i < length) {

        var c = str[i];

        if (c == '"' && (i == 0 || c[i - 1] != '\\')) {
            // non-escaped quotes
            withinQuotes = !withinQuotes;
        }

        if (!withinQuotes && (c == '}' || c == '{' || c == ',')) {

            console.log('Start####' + result);

            // look back and remove carriage returns and whitespace that are already there

            var resultIndex = result.length - 1;
            while (resultIndex >= 0 && (result[resultIndex] == ' ' || result[resultIndex] == '\r' || result[resultIndex] == '\n' || result[resultIndex] == '\t')) {

                resultIndex = resultIndex - 1;
                result = result.substr(0, resultIndex + 1);

                console.log('char ' + result[resultIndex] + '-----' + result + 'zzz ' + result.length + ' ' + resultIndex);

            }


            if (c == '{') {
                braceCountLeft++;
                result += c + '\r' + GetTabs(braceCountLeft - braceCountRight);
            } else if (c == '}') {
                braceCountRight++;
                // precede with carriage return
                result += '\r' + GetTabs(braceCountLeft - braceCountRight) + c;
            } else if (c == ',') {
                result += c + '\r' + GetTabs(braceCountLeft - braceCountRight);
            }

            var nextChar = '';

            // advance through whitespace and remove carriage returns that are already there
            while (i < length && (str[i + 1] == ' ' || str[i + 1] == '\r' || str[i + 1] == '\n' || str[i + 1] == '\t')) {
                i++;
            }

        } else {

            result += str[i];

        }


        i++;

    }

    return result;

}

function GetTabs(count) {

    var result = '';

    for (var i = 0; i < count; i++) {
        result += '    ';
    }

    return result;

}